﻿<?xml version="1.0" encoding="utf-8"?>
<Database Name="Northwind_OrmTest" xmlns="http://schemas.microsoft.com/linqtosql/mapping/2007">
  <Table Name="dbo.Alphabeticallistofproducts" Member="Alphabeticallistofproducts">
    <Type Name="Northwind.Dto.Alphabeticallistofproducts">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int" />
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="UnitsOnOrder" Member="UnitsOnOrder" Storage="_UnitsOnOrder" DbType="SmallInt" />
      <Column Name="ReorderLevel" Member="ReorderLevel" Storage="_ReorderLevel" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit NOT NULL" />
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.Categories" Member="Categories">
    <Type Name="Northwind.Dto.Categories">
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" AutoSync="OnInsert" />
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="Description" Member="Description" Storage="_Description" DbType="NText" UpdateCheck="Never" />
      <Column Name="Picture" Member="Picture" Storage="_Picture" DbType="Image" UpdateCheck="Never" />
      <Association Name="FK_Products_Categories" Member="Products" Storage="_Products" ThisKey="CategoryID" OtherKey="CategoryID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.CategorySalesfor1997" Member="CategorySalesfor1997">
    <Type Name="Northwind.Dto.CategorySalesfor1997">
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="CategorySales" Member="CategorySales" Storage="_CategorySales" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.CurrentProductList" Member="CurrentProductList">
    <Type Name="Northwind.Dto.CurrentProductList">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL IDENTITY" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.CustomerandSuppliersbyCity" Member="CustomerandSuppliersbyCity">
    <Type Name="Northwind.Dto.CustomerandSuppliersbyCity">
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="Relationship" Member="Relationship" Storage="_Relationship" DbType="VarChar(9) NOT NULL" CanBeNull="false" />
    </Type>
  </Table>
  <Table Name="dbo.CustomerCustomerDemo" Member="CustomerCustomerDemo">
    <Type Name="Northwind.Dto.CustomerCustomerDemo">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5) NOT NULL" CanBeNull="false" IsPrimaryKey="true" />
      <Column Name="CustomerTypeID" Member="CustomerTypeID" Storage="_CustomerTypeID" DbType="NChar(10) NOT NULL" CanBeNull="false" IsPrimaryKey="true" />
      <Association Name="FK_CustomerCustomerDemo" Member="CustomerDemographics" Storage="_CustomerDemographics" ThisKey="CustomerTypeID" OtherKey="CustomerTypeID" IsForeignKey="true" />
      <Association Name="FK_CustomerCustomerDemo_Customers" Member="Customers" Storage="_Customers" ThisKey="CustomerID" OtherKey="CustomerID" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.CustomerDemographics" Member="CustomerDemographics">
    <Type Name="Northwind.Dto.CustomerDemographics">
      <Column Name="CustomerTypeID" Member="CustomerTypeID" Storage="_CustomerTypeID" DbType="NChar(10) NOT NULL" CanBeNull="false" IsPrimaryKey="true" />
      <Column Name="CustomerDesc" Member="CustomerDesc" Storage="_CustomerDesc" DbType="NText" UpdateCheck="Never" />
      <Association Name="FK_CustomerCustomerDemo" Member="CustomerCustomerDemo" Storage="_CustomerCustomerDemo" ThisKey="CustomerTypeID" OtherKey="CustomerTypeID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.Customers" Member="Customers">
    <Type Name="Northwind.Dto.Customers">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5) NOT NULL" CanBeNull="false" IsPrimaryKey="true" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
      <Association Name="FK_CustomerCustomerDemo_Customers" Member="CustomerCustomerDemo" Storage="_CustomerCustomerDemo" ThisKey="CustomerID" OtherKey="CustomerID" DeleteRule="NO ACTION" />
      <Association Name="FK_Orders_Customers" Member="Orders" Storage="_Orders" ThisKey="CustomerID" OtherKey="CustomerID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.Employees" Member="Employees">
    <Type Name="Northwind.Dto.Employees">
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" AutoSync="OnInsert" />
      <Column Name="LastName" Member="LastName" Storage="_LastName" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="FirstName" Member="FirstName" Storage="_FirstName" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
      <Column Name="Title" Member="Title" Storage="_Title" DbType="NVarChar(30)" />
      <Column Name="TitleOfCourtesy" Member="TitleOfCourtesy" Storage="_TitleOfCourtesy" DbType="NVarChar(25)" />
      <Column Name="BirthDate" Member="BirthDate" Storage="_BirthDate" DbType="DateTime" />
      <Column Name="HireDate" Member="HireDate" Storage="_HireDate" DbType="DateTime" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="HomePhone" Member="HomePhone" Storage="_HomePhone" DbType="NVarChar(24)" />
      <Column Name="Extension" Member="Extension" Storage="_Extension" DbType="NVarChar(4)" />
      <Column Name="Photo" Member="Photo" Storage="_Photo" DbType="Image" UpdateCheck="Never" />
      <Column Name="Notes" Member="Notes" Storage="_Notes" DbType="NText" UpdateCheck="Never" />
      <Column Name="ReportsTo" Member="ReportsTo" Storage="_ReportsTo" DbType="Int" />
      <Column Name="PhotoPath" Member="PhotoPath" Storage="_PhotoPath" DbType="NVarChar(255)" />
      <Association Name="FK_Employees_Employees" Member="ReportsToEmployees" Storage="_ReportsToEmployees" ThisKey="ReportsTo" OtherKey="EmployeeID" IsForeignKey="true" />
      <Association Name="FK_Employees_Employees" Member="Employee" Storage="_Employee" ThisKey="EmployeeID" OtherKey="ReportsTo" DeleteRule="NO ACTION" />
      <Association Name="FK_EmployeeTerritories_Employees" Member="EmployeeTerritories" Storage="_EmployeeTerritories" ThisKey="EmployeeID" OtherKey="EmployeeID" DeleteRule="NO ACTION" />
      <Association Name="FK_Orders_Employees" Member="Orders" Storage="_Orders" ThisKey="EmployeeID" OtherKey="EmployeeID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.EmployeeTerritories" Member="EmployeeTerritories">
    <Type Name="Northwind.Dto.EmployeeTerritories">
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int NOT NULL" IsPrimaryKey="true" />
      <Column Name="TerritoryID" Member="TerritoryID" Storage="_TerritoryID" DbType="NVarChar(20) NOT NULL" CanBeNull="false" IsPrimaryKey="true" />
      <Association Name="FK_EmployeeTerritories_Employees" Member="Employees" Storage="_Employees" ThisKey="EmployeeID" OtherKey="EmployeeID" IsForeignKey="true" />
      <Association Name="FK_EmployeeTerritories_Territories" Member="Territories" Storage="_Territories" ThisKey="TerritoryID" OtherKey="TerritoryID" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.Invoices" Member="Invoices">
    <Type Name="Northwind.Dto.Invoices">
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="CustomerName" Member="CustomerName" Storage="_CustomerName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Salesperson" Member="Salesperson" Storage="_Salesperson" DbType="NVarChar(31) NOT NULL" CanBeNull="false" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipperName" Member="ShipperName" Storage="_ShipperName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money NOT NULL" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt NOT NULL" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Real NOT NULL" />
      <Column Name="ExtendedPrice" Member="ExtendedPrice" Storage="_ExtendedPrice" DbType="Money" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.orderdetails" Member="Orderdetails">
    <Type Name="Northwind.Dto.Orderdetails">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" IsPrimaryKey="true" />
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" IsPrimaryKey="true" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money NOT NULL" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt NOT NULL" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Real NOT NULL" />
      <Association Name="FK_Order_Details_Orders" Member="Orders" Storage="_Orders" ThisKey="OrderID" OtherKey="OrderID" IsForeignKey="true" />
      <Association Name="FK_Order_Details_Products" Member="Products" Storage="_Products" ThisKey="ProductID" OtherKey="ProductID" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.orderdetailsExtended" Member="OrderdetailsExtended">
    <Type Name="Northwind.Dto.OrderdetailsExtended">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money NOT NULL" />
      <Column Name="Quantity" Member="Quantity" Storage="_Quantity" DbType="SmallInt NOT NULL" />
      <Column Name="Discount" Member="Discount" Storage="_Discount" DbType="Real NOT NULL" />
      <Column Name="ExtendedPrice" Member="ExtendedPrice" Storage="_ExtendedPrice" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.Orders" Member="Orders">
    <Type Name="Northwind.Dto.Orders">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" AutoSync="OnInsert" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipVia" Member="ShipVia" Storage="_ShipVia" DbType="Int" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
      <Association Name="FK_Order_Details_Orders" Member="Orderdetails" Storage="_Orderdetails" ThisKey="OrderID" OtherKey="OrderID" DeleteRule="NO ACTION" />
      <Association Name="FK_Orders_Customers" Member="Customers" Storage="_Customers" ThisKey="CustomerID" OtherKey="CustomerID" IsForeignKey="true" />
      <Association Name="FK_Orders_Employees" Member="Employees" Storage="_Employees" ThisKey="EmployeeID" OtherKey="EmployeeID" IsForeignKey="true" />
      <Association Name="FK_Orders_Shippers" Member="Shippers" Storage="_Shippers" ThisKey="ShipVia" OtherKey="ShipperID" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.OrdersQry" Member="OrdersQry">
    <Type Name="Northwind.Dto.OrdersQry">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="EmployeeID" Member="EmployeeID" Storage="_EmployeeID" DbType="Int" />
      <Column Name="OrderDate" Member="OrderDate" Storage="_OrderDate" DbType="DateTime" />
      <Column Name="RequiredDate" Member="RequiredDate" Storage="_RequiredDate" DbType="DateTime" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="ShipVia" Member="ShipVia" Storage="_ShipVia" DbType="Int" />
      <Column Name="Freight" Member="Freight" Storage="_Freight" DbType="Money" />
      <Column Name="ShipName" Member="ShipName" Storage="_ShipName" DbType="NVarChar(40)" />
      <Column Name="ShipAddress" Member="ShipAddress" Storage="_ShipAddress" DbType="NVarChar(60)" />
      <Column Name="ShipCity" Member="ShipCity" Storage="_ShipCity" DbType="NVarChar(15)" />
      <Column Name="ShipRegion" Member="ShipRegion" Storage="_ShipRegion" DbType="NVarChar(15)" />
      <Column Name="ShipPostalCode" Member="ShipPostalCode" Storage="_ShipPostalCode" DbType="NVarChar(10)" />
      <Column Name="ShipCountry" Member="ShipCountry" Storage="_ShipCountry" DbType="NVarChar(15)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
    </Type>
  </Table>
  <Table Name="dbo.OrderSubtotals" Member="OrderSubtotals">
    <Type Name="Northwind.Dto.OrderSubtotals">
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.Products" Member="Products">
    <Type Name="Northwind.Dto.Products">
      <Column Name="ProductID" Member="ProductID" Storage="_ProductID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" AutoSync="OnInsert" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int" />
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="UnitsOnOrder" Member="UnitsOnOrder" Storage="_UnitsOnOrder" DbType="SmallInt" />
      <Column Name="ReorderLevel" Member="ReorderLevel" Storage="_ReorderLevel" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit NOT NULL" />
      <Association Name="FK_Order_Details_Products" Member="Orderdetails" Storage="_Orderdetails" ThisKey="ProductID" OtherKey="ProductID" DeleteRule="NO ACTION" />
      <Association Name="FK_Products_Categories" Member="Categories" Storage="_Categories" ThisKey="CategoryID" OtherKey="CategoryID" IsForeignKey="true" />
      <Association Name="FK_Products_Suppliers" Member="Suppliers" Storage="_Suppliers" ThisKey="SupplierID" OtherKey="SupplierID" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.ProductsAboveAveragePrice" Member="ProductsAboveAveragePrice">
    <Type Name="Northwind.Dto.ProductsAboveAveragePrice">
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="UnitPrice" Member="UnitPrice" Storage="_UnitPrice" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.ProductSalesfor1997" Member="ProductSalesfor1997">
    <Type Name="Northwind.Dto.ProductSalesfor1997">
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ProductSales" Member="ProductSales" Storage="_ProductSales" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.ProductsbyCategory" Member="ProductsbyCategory">
    <Type Name="Northwind.Dto.ProductsbyCategory">
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="QuantityPerUnit" Member="QuantityPerUnit" Storage="_QuantityPerUnit" DbType="NVarChar(20)" />
      <Column Name="UnitsInStock" Member="UnitsInStock" Storage="_UnitsInStock" DbType="SmallInt" />
      <Column Name="Discontinued" Member="Discontinued" Storage="_Discontinued" DbType="Bit NOT NULL" />
    </Type>
  </Table>
  <Table Name="dbo.QuarterlyOrders" Member="QuarterlyOrders">
    <Type Name="Northwind.Dto.QuarterlyOrders">
      <Column Name="CustomerID" Member="CustomerID" Storage="_CustomerID" DbType="NChar(5)" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
    </Type>
  </Table>
  <Table Name="dbo.Region" Member="Region">
    <Type Name="Northwind.Dto.Region">
      <Column Name="RegionID" Member="RegionID" Storage="_RegionID" DbType="Int NOT NULL" IsPrimaryKey="true" />
      <Column Name="RegionDescription" Member="RegionDescription" Storage="_RegionDescription" DbType="NChar(50) NOT NULL" CanBeNull="false" />
      <Association Name="FK_Territories_Region" Member="Territories" Storage="_Territories" ThisKey="RegionID" OtherKey="RegionID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.SalesbyCategory" Member="SalesbyCategory">
    <Type Name="Northwind.Dto.SalesbyCategory">
      <Column Name="CategoryID" Member="CategoryID" Storage="_CategoryID" DbType="Int NOT NULL" />
      <Column Name="CategoryName" Member="CategoryName" Storage="_CategoryName" DbType="NVarChar(15) NOT NULL" CanBeNull="false" />
      <Column Name="ProductName" Member="ProductName" Storage="_ProductName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ProductSales" Member="ProductSales" Storage="_ProductSales" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.SalesTotalsbyAmount" Member="SalesTotalsbyAmount">
    <Type Name="Northwind.Dto.SalesTotalsbyAmount">
      <Column Name="SaleAmount" Member="SaleAmount" Storage="_SaleAmount" DbType="Money" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
    </Type>
  </Table>
  <Table Name="dbo.Shippers" Member="Shippers">
    <Type Name="Northwind.Dto.Shippers">
      <Column Name="ShipperID" Member="ShipperID" Storage="_ShipperID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" AutoSync="OnInsert" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Association Name="FK_Orders_Shippers" Member="Orders" Storage="_Orders" ThisKey="ShipperID" OtherKey="ShipVia" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.SummaryofSalesbyQuarter" Member="SummaryofSalesbyQuarter">
    <Type Name="Northwind.Dto.SummaryofSalesbyQuarter">
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.SummaryofSalesbyYear" Member="SummaryofSalesbyYear">
    <Type Name="Northwind.Dto.SummaryofSalesbyYear">
      <Column Name="ShippedDate" Member="ShippedDate" Storage="_ShippedDate" DbType="DateTime" />
      <Column Name="OrderID" Member="OrderID" Storage="_OrderID" DbType="Int NOT NULL" />
      <Column Name="Subtotal" Member="Subtotal" Storage="_Subtotal" DbType="Money" />
    </Type>
  </Table>
  <Table Name="dbo.Suppliers" Member="Suppliers">
    <Type Name="Northwind.Dto.Suppliers">
      <Column Name="SupplierID" Member="SupplierID" Storage="_SupplierID" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" AutoSync="OnInsert" />
      <Column Name="CompanyName" Member="CompanyName" Storage="_CompanyName" DbType="NVarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="ContactName" Member="ContactName" Storage="_ContactName" DbType="NVarChar(30)" />
      <Column Name="ContactTitle" Member="ContactTitle" Storage="_ContactTitle" DbType="NVarChar(30)" />
      <Column Name="Address" Member="Address" Storage="_Address" DbType="NVarChar(60)" />
      <Column Name="City" Member="City" Storage="_City" DbType="NVarChar(15)" />
      <Column Name="Region" Member="Region" Storage="_Region" DbType="NVarChar(15)" />
      <Column Name="PostalCode" Member="PostalCode" Storage="_PostalCode" DbType="NVarChar(10)" />
      <Column Name="Country" Member="Country" Storage="_Country" DbType="NVarChar(15)" />
      <Column Name="Phone" Member="Phone" Storage="_Phone" DbType="NVarChar(24)" />
      <Column Name="Fax" Member="Fax" Storage="_Fax" DbType="NVarChar(24)" />
      <Column Name="HomePage" Member="HomePage" Storage="_HomePage" DbType="NText" UpdateCheck="Never" />
      <Association Name="FK_Products_Suppliers" Member="Products" Storage="_Products" ThisKey="SupplierID" OtherKey="SupplierID" DeleteRule="NO ACTION" />
    </Type>
  </Table>
  <Table Name="dbo.Territories" Member="Territories">
    <Type Name="Northwind.Dto.Territories">
      <Column Name="TerritoryID" Member="TerritoryID" Storage="_TerritoryID" DbType="NVarChar(20) NOT NULL" CanBeNull="false" IsPrimaryKey="true" />
      <Column Name="TerritoryDescription" Member="TerritoryDescription" Storage="_TerritoryDescription" DbType="NChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="RegionID" Member="RegionID" Storage="_RegionID" DbType="Int NOT NULL" />
      <Association Name="FK_EmployeeTerritories_Territories" Member="EmployeeTerritories" Storage="_EmployeeTerritories" ThisKey="TerritoryID" OtherKey="TerritoryID" DeleteRule="NO ACTION" />
      <Association Name="FK_Territories_Region" Member="Region" Storage="_Region" ThisKey="RegionID" OtherKey="RegionID" IsForeignKey="true" />
    </Type>
  </Table>
</Database>